package com.bothin.experiment4.dao;

import com.bothin.experiment4.model.LogistInfo;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

public interface LogistInfoMapper extends Mapper<LogistInfo> {
    @Select("SELECT * FROM `logist_info` WHERE form_id = #{formId}")
    public List<LogistInfo> findByFormId(String formId);

    @Select("SELECT * FROM `logist_info`\n" +
            "WHERE id LIKE #{key} OR form_id LIKE #{key} OR logist_company LIKE #{key}  ")
    public List<LogistInfo> findByKeyword(String key);
}